cd "%~dp0"


SQLCMD -S %COMPUTERNAME%\UNCLEBOB -i "DatabaseCreationScript.sql"

SQLCMD -S %COMPUTERNAME%\UNCLEBOB -d AESDB -U sa -P Uncl3B0b -i "UserRegistrationTable.sql"

SQLCMD -S %COMPUTERNAME%\UNCLEBOB -d AESDB -U sa -P Uncl3B0b -i "CreateQuestionsTable.sql"

SQLCMD -S %COMPUTERNAME%\UNCLEBOB -d AESDB -U sa -P Uncl3B0b -i "CreateQuestionAnswersTable.sql"

SQLCMD -S %COMPUTERNAME%\UNCLEBOB -d AESDB -U sa -P Uncl3B0b -i "CreateJobsTable.sql"

SQLCMD -S %COMPUTERNAME%\UNCLEBOB -d AESDB -U sa -P Uncl3B0b -i "CreateAccessTable.sql"

SQLCMD -S %COMPUTERNAME%\UNCLEBOB -d AESDB -U sa -P Uncl3B0b -i "DropAndRecreateJobs.sql"

SQLCMD -S %COMPUTERNAME%\UNCLEBOB -d AESDB -U sa -P Uncl3B0b -i "DropAndCreateAccessTable.sql"

SQLCMD -S %COMPUTERNAME%\UNCLEBOB -d AESDB -U sa -P Uncl3B0b -i "CreateJobApplications.sql"

SQLCMD -S %COMPUTERNAME%\UNCLEBOB -d AESDB -U sa -P Uncl3B0b -i "CreateUserJobQuestions.sql"

SQLCMD -S %COMPUTERNAME%\UNCLEBOB -d AESDB -U sa -P Uncl3B0b -i "DropApplicant_Job_Submit.sql"

SQLCMD -S %COMPUTERNAME%\UNCLEBOB -d AESDB -U sa -P Uncl3B0b -i "DropAndCreateUserJobQuestions.sql"

SQLCMD -S %COMPUTERNAME%\UNCLEBOB -d AESDB -U sa -P Uncl3B0b -i "DropAndCreateJobs.sql"

SQLCMD -S %COMPUTERNAME%\UNCLEBOB -d AESDB -U sa -P Uncl3B0b -i DropAndCreateJobApplications.sql"

SQLCMD -S %COMPUTERNAME%\UNCLEBOB -d AESDB -U sa -P Uncl3B0b -i CreateJobAppCommentsTable.sql"

echo *********************************  DB Update complete *********************
